package campus.aiit.ssl.dao;

import campus.aiit.ssl.domain.model.Department;
import campus.aiit.ssl.manage.custom.dao.BaseDao;

import java.math.BigInteger;
import java.util.List;
import java.util.Map;

public interface StatisticsDao extends BaseDao<Department> {

    List<Map<String, Object>> getDeviceNum(Long blockId, Long deviceTypeId);

    List<Map<String, Object>> getTotalECForType(Long blockId,Long deviceTypeId,String startTime,String endTime);

    List<Map<String, Object>> getECOfDeviceType(Long blockId, Long deviceTypeId, String startTime, String endTime);

    List<Map<String, Object>> getTotalECOfAllBlock();

    List<Map<String, Object>> getECOfBlock(Long blockId, Long deviceTypeId, String startTime, String endTime);

    List<Map<String, Object>> getECOfDevice(Long deviceId, String startTime, String endTime);

    List<Map<String, Object>> getDays(String startTime, String endTime);

    List<Map<String, Object>> getTotalDeviceNumOfBlock(Long deviceTypeId);

    BigInteger getMonthECByDeviceId(Long deviceId, String startTime, String endTime);

}
